This appendix contains sample reports.
With PBS Accounts Payable you have a choice of several check formats. A check format is assigned in A/P Control information. This is a sample check of check format 1 printed on a laser printer:
Check format 2 is similar to check format 2 with reference except the reference does not print after every invoice line.
Check format 1 on blank stub is similar to check format 1, but the column names print on the stub making it easier to align the data with the check form.
Date 03/10/2015 Time 13:09:54 XYZ Company Report #0037 Page 0001
V E N D O R S B Y V E N D O R #
Starting vendor #: “First” Payment group: “All”
Ending vendor #: “Last” A/P account #: “All”
Vendor status: Blank = normal A = always take discount H = hold payment N = not to be purchased from
Terms types: D = days P = proximo (day of next month)
EOM = end of current month
------------------------------------------------------------------------------------------------------------------------------------
Vend-# Name Contact-1 Phone-1 1099-ID-# A/P-Acct-# ---- Terms -----
Status Address Contact-2 Phone-2 1099-ID-type Disc-acct-# Type Due-days
Type Vend-ref-# Last-purch-date 1099-amt-YTD Dflt-dist-acct-# Cutoff Disc-days
Pmt-grp Current-Balance 1099-amt-nxt-yr Disc-%
------------------------------------------------------------------------------------------------------------------------------------
100 Vermont Metal Products John Smith 802-445-9134 12-7659821 2000-000 2/10 net 31
A 410 Pinecrest Road Howard Brice 802-445-9136 Business 5050-100 Proximo 10th
MFG 12769 1/28/15 4,596.69 5010-100 EOM 10th
MFG Newton VT 12345 12,848.13 0.00 2.00
Country: USA
------------LAST CHECK-------------
PTD YTD Last-year # DATE AMT
----------------- ----------------- ----------------- ------ -------- -----------------
Purchases 17,538.63 17,538.63 0.00 1016 9/28/14 4,596.69
Discounts 93.81 93.81 0.00 0 0.00
Payments 4,596.69 4,596.69 0.00 110 9/28/14 1,470.00
------------LAST CHECK-------------
Date 03/10/2015 Time 13:09:54 XYZ Company Report #0037 Page 0004
V E N D O R S B Y V E N D O R #
------------LAST CHECK-------------
PTD YTD Last-year # DATE AMT
----------------- ----------------- ----------------- ------ -------- -----------------
Purchases 12,575.45 12,575.45 0.00 0 0.00
Discounts 0.00 0.00 0.00 112 9/28/14 22,600.00
Payments 0.00 0.00 0.00 0 0.00
11 Vendors on file
-- End of report --
Date 03/10/2015 Time 13:21:06 XYZ Company Report #0038 Page 0001
V E N D O R S B Y V E N D O R N A M E
Starting vendor name: “First” Payment group: “All”
Ending vendor name: “Last” A/P account #: “All”
Vendor status: Blank = normal A = always take discount H = hold payment N = not to be purchased from
Terms types: D = days P = proximo (day of next month)
EOM = end of current month
------------------------------------------------------------------------------------------------------------------------------------
Vend-# Name Contact-1 Phone-1 1099-ID-# A/P-Acct-# ---- Terms -----
Status Address Contact-2 Phone-2 1099-ID-type Disc-acct-# Type Due-days
Type Vend-ref-# Last-purch-date 1099-amt-YTD Dflt-dist-acct-# Cutoff Disc-days
Pmt-grp Current-Balance 1099-amt-nxt-yr Disc-%
------------------------------------------------------------------------------------------------------------------------------------
200 Acme Office Supplies B Caldwell 213-999-9765 12-3456789 2000-000 2/15 net 30
456 N. Broadway Business 5050-100 Days 30
CAP 1/23/15 67.59 7500-100 N/A 15
SPL Los Angeles CA 90101 18,323.25 0.00 2.00
Country: USA
------------LAST CHECK-------------
PTD YTD Last-year # DATE AMT
----------------- ----------------- ----------------- ------ -------- -----------------
Purchases 18,390.84 18,390.84 0.00 8 1/20/15 67.59
Discounts 0.00 0.00 0.00 0 0.00
Payments 67.59 67.59 0.00 0 0.00
500 E-Z Repairs Betty Smith 213-695-2101 2000-000 net 30
900 S. Vermont Avenue Sandra Kitts 213-695-2102 5050-100 Days 30
EXP 1/22/15 0.00 8500-100 N/A None
RPR Los Angeles CA 90005 4,064.00 0.00 0.00
Country: USA
Fax-1: 213-695-2100 Email-1: Bsmith@EZrepair.com Fax-2: 213-695-2100 Email-2: skitts@ezrepair.com
------------LAST CHECK-------------
Date 03/10/2015 Time 13:21:06 XYZ Company Report #0038 Page 0004
V E N D O R S B Y V E N D O R N A M E
------------------------------------------------------------------------------------------------------------------------------------
Vend-# Name Contact-1 Phone-1 1099-ID-# A/P-Acct-# ---- Terms -----
Status Address Contact-2 Phone-2 1099-ID-type Disc-acct-# Type Due-days
Type Vend-ref-# Last-purch-date 1099-amt-YTD Dflt-dist-acct-# Cutoff Disc-days
Pmt-grp Current-Balance 1099-amt-nxt-yr Disc-%
------------------------------------------------------------------------------------------------------------------------------------
100 Vermont Metal Products John Smith 802-445-9134 12-7659821 2000-000 2/10 net 31
A 410 Pinecrest Road Howard Brice 802-445-9136 Business 5050-100 Proximo 10th
MFG 12769 1/28/15 4,596.69 5010-100 EOM 10th
MFG Newton VT 12345 12,848.13 0.00 2.00
Country: USA
------------LAST CHECK-------------
PTD YTD Last-year # DATE AMT
----------------- ----------------- ----------------- ------ -------- -----------------
Purchases 17,538.63 17,538.63 0.00 1016 9/28/14 4,596.69
Discounts 93.81 93.81 0.00 0 0.00
Payments 4,596.69 4,596.69 0.00 110 9/28/14 1,470.00
600 Wells Fargo Bank Jack Dawson 213-695-4670 2000-000 Bank Charges
Mason/Beverly Branch Mary Andrews 213-695-4680 5050-100 Days 0
EXP 4031 N. Mason 1/22/15 0.00 7100-100 N/A None
BNK Los Angeles CA 91206 103.75 0.00 0.00
Country: USA
------------LAST CHECK-------------
PTD YTD Last-year # DATE AMT
----------------- ----------------- ----------------- ------ -------- -----------------
Purchases 103.75 103.75 0.00 0 0.00
Discounts 0.00 0.00 0.00 0 0.00
Payments 0.00 0.00 0.00 0 0.00
11 Vendors on file
-- End of report --
Date 03/10/2015 Time 13:36:27 XYZ Company Report #0039 Page 0001
V E N D O R C H A N G E L O G
Vendor status: Blank = normal A = always take discount H = hold payment N = not to be purchased from
Terms type: D = days P = proximo (day of next month)
------------------------------------------------------------------------------------------------------------------------------------
Vend-# Name Contact-1 Phone-1 1099-ID-# A/P-Acct-# Terms Desc.
Status Address Contact-2 Phone-2 1099-ID-type Disc-acct-# Type Due-days
Type Vend-ref-# Last-purch-date 1099-amt-YTD Dflt-dist-acct-# Cutoff Disc-days
Pmt-grp Current-Balance 1099-amt-nxt-yr Disc-%
------------------------------------------------------------------------------------------------------------------------------------
200 Acme Office Supplies B Caldwell 213-999-9765 12-3456789 2000-000 2/15 net 30
456 N. Broadway Business 5050-100 D 30
CAP 1/23/15 67.59 7500-100 15
SPL Los Angeles, CA 90101 18,323.25 0.00 2.00
Fax-1: Email-1: POS@AcmeOS.com Fax-2: Email-2:
Country: USA -------------LAST CHECK-------------
PTD YTD Last-year # DATE AMT
----------------- ----------------- ----------------- ------ -------- -----------------
Purchases 18,390.84 18,390.84 0.00 8 1/20/15 67.59
Discounts 0.00 0.00 0.00 0 0.00
Payments 67.59 67.59 0.00 0 0.00
Changed by: RWA on 03/10/15 to become
200 Acme Office Supplies Barb Caldwell 213-999-9765 12-3456789 2000-000 2/15 net 30
***************
456 N. Broadway Business 5050-100 D 30
CAP 1/23/15 67.59 7500-100 15
SPL Los Angeles, CA 90101 18,323.25 0.00 2.00
Fax-1: Email-1: POS@AcmeOS.com Fax-2: Email-2:
Country: USA -------------LAST CHECK-------------
PTD YTD Last-year # DATE AMT
----------------- ----------------- ----------------- ------ -------- -----------------
Purchases 18,390.84 18,390.84 0.00 8 1/20/15 67.59
Discounts 0.00 0.00 0.00 0 0.00
Payments 67.59 67.59 0.00 0 0.00
------------------------------------------------------------------------------------------------------------------------------------
400 Jones Property Management Robert Jones 213-774-6700 2000-000 Monthly payment
11056 Wilshire Blvd. Danielle Lutz 213-774-6701 5050-100 D 4
EXP Suite 4250 1/23/15 0.00 8000-100 0
RNT Los Angeles, CA 92251 14,550.00 0.00 0.00
Fax-1: Email-1: Fax-2: Email-2:
Country: USA -------------LAST CHECK-------------
PTD YTD Last-year # DATE AMT
----------------- ----------------- ----------------- ------ -------- -----------------
Purchases 14,742.60 14,742.60 0.00 1017 9/28/14 192.60
Discounts 0.00 0.00 0.00 0 0.00
Payments 192.60 192.60 0.00 0 0.00
Changed by: RWA on 03/10/14 to become
400 Jones Property Management Robert Jones 213-774-6700 2000-000 Monthly payment
11056 Wilshire Avenue Danielle Lutz 213-774-6701 5050-100 D 4
******************************
EXP Suite 4250 1/23/15 0.00 8000-100 0
Date 03/10/2015 Time 13:36:27 XYZ Company Report #0039 Page 0002
V E N D O R C H A N G E L O G
------------------------------------------------------------------------------------------------------------------------------------
Vend-# Name Contact-1 Phone-1 1099-ID-# A/P-Acct-# Terms Desc.
Status Address Contact-2 Phone-2 1099-ID-type Disc-acct-# Type Due-days
Type Vend-ref-# Last-purch-date 1099-amt-YTD Dflt-dist-acct-# Cutoff Disc-days
Pmt-grp Current-Balance 1099-amt-nxt-yr Disc-%
------------------------------------------------------------------------------------------------------------------------------------
RNT Los Angeles, CA 92251 14,550.00 0.00 0.00
Fax-1: Email-1: Fax-2: Email-2:
Country: USA -------------LAST CHECK-------------
PTD YTD Last-year # DATE AMT
----------------- ----------------- ----------------- ------ -------- -----------------
Purchases 14,742.60 14,742.60 0.00 1017 9/28/14 192.60
Discounts 0.00 0.00 0.00 0 0.00
Payments 192.60 192.60 0.00 0 0.00
------------------------------------------------------------------------------------------------------------------------------------
2 Changes on file
-- End of report --
Date 03/10/2015 Time 14:23:54 XYZ Company Report #0040 Page 0001
P U R C H A S I N G A D D R E S S E S
Starting vendor #: “First”
Ending vendor #: “Last”
------------------------------------------------------------------------------------------------------------------------------------
Vend-# Name Loc-# Loc-name Contact-1 Contact-2
Address Loc-address Phone Phone
Fax Fax
E-mail E-mail
------------------------------------------------------------------------------------------------------------------------------------
300 Red Line Freight 1-002 Red Line Freight Tim Rawlings
22748 E. Commercial Building 4-D 213-555-9933
Los Angeles, CA 92251 1000 Industrial Park Rd.
Country: USA Los Angeles, CA 92251
Country: USA
700 Pacific Telephone LA Los Angeles Office Mike Douglas
Glendale Office 322 Independence Way 813-908-4444
500 N. Central Los Angeles, CA 90210
Glendale, CA 91206 Country: USA
Country: USA
800 Hanson Manufacturing Co. NW Northwest Office Gregory Hines
65 Industrial Circle 2344 W. Hoodview 833-877-8832
Chicago, IL 30555 Portland OR 97332
Country: USA Country: USA
RM Rocky Mountains Office William Hurt
4500 Boulder 609-332-4478
Denver, CO 80504
Country: USA
SW Southwest Office G.B. Shaw
533 N Green 414-988-0021
Los Angeles, CA 91210
Country: USA
5 Purchasing addresses on file
-- End of report --
Date 03/10/2015 Time 15:52:08 XYZ Company Report #0041 Page 0001
P A Y A B L E S E D I T L I S T
Voucher types: R = Regular N = Non-A/P check C = Cancellation A = Adjustment to distribution I = Immediate check
------------------------------------------------------------------------------------------------------------------------------------
Vchr-# Vend-# Vendor-name Inv-date Invoice-# Inv-amt Due-day(s) Due-date Chk-# Chk-date Rept
Type Vendor-terms Dist-dat Prch-ord-# Non-disc-amt Disc-day(s) Disc-date Cash-account on
Reference Rcvr-# Rcvr-# Disc-pct Disc-amt Discount-account 1099?
------------------------------------------------------------------------------------------------------------------------------------
1083 100 Vermont Metal Products 3/10/15 44455 125.60 10th 4/10/15
R 2/10 net 31 3/10/15 .00 10th 4/10/15
2.00 2.51 5050-100 Yes
Distribution: 5010-100 Purchases - misc. items 125.60
1084 300 Red Line Freight 3/10/15 4938 39.00 15th 4/15/15
R net 30 3/10/15 .00 None None
N/A Yes
Distribution: 5010-100 Purchases - misc. items 5.00
5040-100 Freight - purchases 34.00
1085 100 Vermont Metal Products 3/10/15 934898 399.34 10th 4/10/15
R 2/10 net 31 3/10/15 34.00 10th 4/10/15
2.00 7.31 5050-100 No
Distribution: 5010-100 Purchases - misc. items 399.34
Date 03/10/2015 Time 15:52:08 XYZ Company Report #0041 Page 0002
P A Y A B L E S E D I T L I S T
--------------------------------Transaction totals-------------------------------
3 transactions entered Invoice amt total: 563.94
3 reg vouchers 0 cancellations 0 adjustments 0 non-A/P checks
Acct-# Description Debits Credits
Distribution summary: 2000-000 Accounts payable .00 563.94
5010-100 Purchases - misc. items 529.94 .00
5040-100 Freight - purchases 34.00 .00
--------------------------------------
Totals: 563.94 563.94
-- End of report --
Date 03/10/2015 Time 15:52:30 XYZ Company Report #0042 Page 0001
Voucher types: R = Regular N = Non-A/P check C = Cancellation A = Adjustment to distribution I = Immediate check
------------------------------------------------------------------------------------------------------------------------------------
Vchr-# Vend-# Vendor-name Inv-date Invoice-# Inv-amt Due-day(s) Due-date Chk-# Chk-date Rept
Type Vendor-terms Dist-dat Prch-ord-# Non-disc-amt Disc-day(s) Disc-date Cash-account on
Reference Rcvr-# Rcvr-# Disc-pct Disc-amt Discount-account 1099?
------------------------------------------------------------------------------------------------------------------------------------
1083 100 Vermont Metal Products 3/10/15 44455 125.60 10th 4/10/15
R 2/10 net 31 3/10/15 .00 10th 4/10/15
2.00 2.51 5050-100 Yes
Distribution: 5010-100 Purchases - misc. items 125.60
1084 300 Red Line Freight 3/10/15 4938 39.00 15th 4/15/15
R net 30 3/10/15 .00 None None
N/A Yes
Distribution: 5010-100 Purchases - misc. items 5.00
5040-100 Freight - purchases 34.00
Date 03/10/2015 Time 15:52:30 XYZ Company Report #0042 Page 0002
P A Y A B L E S R E G I S T E R
--------------------------------Transaction totals-------------------------------
3 transactions entered Invoice amt total: 563.94
3 reg vouchers 0 cancellations 0 adjustments 0 non-A/P checks
Acct-# Description Debits Credits
Distribution summary: 2000-000 Accounts payable .00 563.94
5010-100 Purchases - misc. items 529.94 .00
5040-100 Freight - purchases 34.00 .00
--------------------------------------
Totals: 563.94 563.94
-- End of report --
Date 03/10/2015 Time 16:55:15 XYZ Company Report #0043 Page 0001
R E C U R R I N G P A Y A B L E S E D I T L I S T
Starting vendor #: “First”
Ending vendor #: “Last”
Entry types shown: Fixed (F) and variable (V) amounts
Next date cut-off: “Latest”
------------------------------------------------------------------------------------------------------------------------------------
Grp Vend-# Name Due-day(s) Amount-due Amt-YTD Total-to-date Last-vchr Selected? Expired?
Inv-cd Reference Disc-day(s) Non-disc-amt Annual-max Max-total-amt Last-date Start-date Times-used
Type P.O. # Rpt-on-1099? Disc-pct Discount Disc-acct Interval Next-date Final-date Max-uses
------------------------------------------------------------------------------------------------------------------------------------
OFC 200 Acme Office Supplies 30 156.00 .00 .00 (none) N N
SUPPLY Front desk supplies 15 Indefinite Indefinite (none) (none) 0
F 224012 Yes 2.00 3.12 5050-100 Every 1 Months 3/10/15 Indefinite Indefinite
Acct-# Description Amount
Distribution: 7500-100 Office supplies 156.00
EXP 400 Jones Property Management 4 3,500.00 .00 .00 (none) N N
RNT-1 Monthly Office Rent 0 Indefinite Indefinite (none) (none) 0
F No .00 Every 1 Months 1/31/15 Indefinite Indefinite
Acct-# Description Amount
Distribution: 8000-100 Rent 3,500.00
2 entries printed
-- End of report --
Recurring Payables Selection List
Date 03/11/2015 Time 11:42:54 XYZ Company Report #0044 Page 0001
R E C U R R I N G P A Y A B L E S S E L E C T I O N L I S T
“TBA” means “To be assigned”. Voucher numbers and TBA invoice numbers will be automatically assigned during posting.
------------------------------------------------------------------------------------------------------------------------------------
Group Vend-# Vendor-name Inv-date Invoice-# Invoice-amt Due-day(s) Due-date Chk-# Chk-date Rept
Inv-cd Vendor-terms Dist-dat Prch-ord-# Non-disc-amt Disc-day(s) Disc-date Cash-account on
Type Reference Vchr-# Disc-pct Disc-amt Discount-account 1099?
------------------------------------------------------------------------------------------------------------------------------------
OFC 200 Acme Office Supplies 3/10/15 (TBA) 156.00 30 4/09/15
SUPPLY 2/15 net 30 3/10/15 224012 .00 15 3/25/15
F Front desk supplies (TBA) 2.00 3.12 5050-100 Yes
Acct-# Description Amount
Distribution: 7500-100 Office supplies 156.00
1 transaction selected Invoice amt total: 156.00
Acct-# Description Debits Credits
Distribution summary: 2000-000 Accounts payable .00 156.00
7500-100 Office supplies 156.00 .00
-------------------------------------
Totals: 156.00 156.00
-- End of report --
Recurring Payables Automatic Selection Edit List
Date 03/11/2015 Time 11:44:09 XYZ Company Report #0045 Page 0001
R E C U R R I N G P A Y A B L E S A U T O M A T I C S E L E C T I O N E D I T L I S T
Starting vendor #: “First”
Ending vendor #: “Last”
Next date cut-off: 4/01/15
------------------------------------------------------------------------------------------------------------------------------------
Grp Vend-# Name Due-day(s) Amount-due Amt-YTD Total-to-date Last-vchr Selected? Expired?
Inv-cd Reference Disc-day(s) Non-disc-amt Annual-max Max-total-amt Last-date Start-date Times-used
Type P.O. # Rpt-on-1099? Disc-pct Discount Disc-acct Interval Next-date Final-date Max-uses
------------------------------------------------------------------------------------------------------------------------------------
EXP 400 Jones Property Management 4 3,500.00 .00 .00 (none) Y N
RNT-1 Monthly Office Rent 0 Indefinite Indefinite (none) (none) 0
F NO .00 Every 1 Months 1/31/15 Indefinite Indefinite
1 entry printed 1 entry selected 0 entries with errors
-- End of report --
Date 03/11/2015 Time 12:18:29 XYZ Company Report #0046 Page 0001
A G E D O P E N I T E M S D E T A I L
Selections for this report: Aging periods:
1. Aging date 3/11/15 1. Define aging periods by Days
2. Age by invoice or due date Invoice date
2. # aging days in prd 1 30
3. By vendor number or name Number 3. Period 1 description Current
4. Starting vendor “First”
5. Ending vendor “Last”
4. # aging days in prd 2 60
6. Group by A/P account ? Y 5. Period 2 description Over 30 days
7. For which A/P account “All”
8. Show zero bal vendors ? Y 6. # aging days in prd 3 90
7. Period 3 description Over 60 days
9. Detail or summary ? Detail
10. Vendor payment group “All”
11. Print invoice # or P.O.# Invoice # 8. # aging days in prd 4 999
9. Period 4 description Over 90 days
Date 03/11/2015 Time 12:18:29 XYZ Company Report #0046 Page 0001
A G E D O P E N I T E M S D E T A I L
Aged as of 03/11/15 based upon invoice dates
Note: Asterisk (*) beside voucher means item is permanently deferred
------------------------------------------------------------------------------------------------------------------------------------
Vend-# Name Vendor-balance --------------------------Aged vendor net--------------------------
Contact-1 Address-1 Valid-discounts Current Over 30 days Over 60 days Over 90 days
Phone-1 Address-2 Vendor-net
Phone-2 Address-3 Last-prch-date
------------------------------------------------------------------------------------------------------------------------------------
A/P account: 2000-000 Accounts payable
===============================================================
100 Vermont Metal Products 8,266.09 515.12 7,586.33 .00 .00
John Smith 410 Pinecrest Road 164.64 6 % 94 % 0 % 0 %
802-445-9134 8,101.45
802-445-9136 Newton, VT 12345 3/10/15 Payment group: MFG Terms: 2/10 net 31
Country: USA
Vchr-# Dst-date Invoice # Inv-date Due-date Dsc-date Invoice-amount Amount-paid Valid-disc Invoice-net Age
1061 1/24/15 34 1/24/15 2/10/15 2/10/15 965.60 .00 19.31 946.29 46
1071 1/24/15 5 1/24/15 2/10/15 2/10/15 925.00 .00 18.50 906.50 46
1074 1/28/15 490 1/28/15 2/10/15 2/10/15 3,500.00 .00 70.00 3,430.00 42
1075 1/27/15 401 1/27/15 2/10/15 2/10/15 2,350.55 .00 47.01 2,303.54 43
1083 3/10/15 44455 3/10/15 4/10/15 4/10/15 125.60 .00 2.51 123.09 1
1085 3/10/15 934898 3/10/15 4/10/15 4/10/15 399.34 .00 7.31 392.03 1
200 Acme Office Supplies 6,223.25 .00 6,223.25 .00 .00
Barb Caldwell 456 N. Broadway .00 0 % 100 % 0 % 0 %
213-999-9765 6,223.25
Los Angeles, CA 90101 1/23/15 Payment group: SPL Terms: 2/15 net 30
Country: USA
Vchr-# Dst-date Invoice # Inv-date Due-date Dsc-date Invoice-amount Amount-paid Valid-disc Invoice-net Age
1059 1/22/15 10 1/22/15 2/21/15 2/06/15 1,625.00 .00 .00 1,625.00 48
1062 1/23/15 35 1/23/15 2/22/15 2/07/15 2,500.75 .00 .00 2,500.75 47
1073 1/23/15 2 1/23/15 2/22/15 2/07/15 2,097.50 .00 .00 2,097.50 47
300 Red Line Freight 489.45 39.00 450.45 .00 .00
Carl Rawlings 22748 E. Commercial .00 8 % 92 % 0 % 0 %
213-768-7650 489.45
213-768-7660 Los Angeles, CA 92251 3/10/15 Payment group: EXP Terms: net 30
Country: USA
Vchr-# Dst-date Invoice # Inv-date Due-date Dsc-date Invoice-amount Amount-paid Valid-disc Invoice-net Age
1063 1/23/15 36 1/23/15 2/15/15 450.45 .00 .00 450.45 47
1084 3/10/15 4938 3/10/15 4/15/15 39.00 .00 .00 39.00 1
Date 03/11/2015 Time 12:18:30 XYZ Company Report #0046 Page 0004
A G E D O P E N I T E M S D E T A I L
Aged as of 03/11/15 based upon invoice dates
Note: Asterisk (*) beside voucher means item is permanently deferred
------------------------------------------------------------------------------------------------------------------------------------
Vend-# Name Vendor-balance --------------------------Aged vendor net--------------------------
Contact-1 Address-1 Valid-discounts Current Over 30 days Over 60 days Over 90 days
Phone-1 Address-2 Vendor-net
Phone-2 Address-3 Last-prch-date
------------------------------------------------------------------------------------------------------------------------------------
Totals for: 2000-000 Accounts payable
Gross-bal Valid-disc Net-bal Current Over 30 days Over 60 days Over 90 days
----------------------------------------------------------------------------------------------------
44323.90 415.67 43908.23 554.12 1 % 43354.11 99 % .00 0 % .00 0 %
====================================================================================================
-- End of report --
Date 03/11/2015 Time 15:21:21 XYZ Company Report #0048 Page 0001
M O D I F Y O P E N I T E M R E G I S T E R
Modify types: C = change due date,disc date, disc bal M = mark voucher as manually paid
------------------------------------------------------------------------------------------------------------------------------------
Type Vend-# Vch-# Inv-# Inv-bal Due-date Disc-date Discount-bal Chk-# Amount-paid
Name Inv-date Chk-date Disc-taken
Rpt-on-1099 Check-amount
------------------------------------------------------------------------------------------------------------------------------------
C 100 1061 34 965.60 Old: 2/10/15 2/10/15 19.31
Vermont Metal Products 1/24/15 New: 4/10/15 4/10/15 19.31
Yes
C 300 1084 4938 39.00 Old: 4/15/15 None .00
Red Line Freight 3/10/15 New: 4/15/15 None .00
Yes
0 A/P Manual checks Grand totals: .00
2 A/P due/disc date, disc bal adjustments .00
2 A/P open item adjustments .00
-- End of report --
Date 03/11/2015 Time 15:32:58 XYZ Company Report #0049 Page 0001
C A S H D I S B U R S E M E N T S P R O J E C T I O N
Starting vendor #: “First” A/P account #: “All”
Ending vendor #: “Last” Payment group: “All”
------------------------------------------------------------------------------------------------------------------------------------
--------Cash required for------- WEEK WEEK MON MON MON QTR
Vend-# Vchr-# As-of Amount ending ending ending ending ending ending
Pmt-grp date 3/11/15 3/18/15 4/18/15 5/18/15 6/18/15 9/18/15
------------------------------------------------------------------------------------------------------------------------------------
100 1061 4/10/15 965.60 966
MFG 1071 2/10/15 925.00 925
1074 2/10/15 3,500.00 3,500
1075 2/10/15 2,350.55 2,351
1083 4/10/15 125.60 126
1085 4/10/15 399.34 399
Vendor 100 totals: 8,266.09 6,776 1,491
200 1059 2/21/15 1,625.00 1,625
SPL 1062 2/22/15 2,500.75 2,501
1073 2/22/15 2,097.50 2,098
Vendor 200 totals: 6,223.25 6,223
300 1063 2/15/15 450.45 450
EXP 1084 4/15/15 39.00 39
Vendor 300 totals: 489.45 450 39
400 1064 1/27/15 11,000.00 11,000
RNT
Vendor 400 totals: 11,000.00 11,000
500 1065 2/21/15 875.00 875
RPR
Vendor 500 totals: 875.00 875
600 1066 1/22/15 65.00 65
BNK
Vendor 600 totals: 65.00 65
700 1067 2/14/15 990.34 990
UTL
Vendor 700 totals: 990.34 990
800 1057 3/24/15 1,275.00 1,275
MFG 1060 3/25/15 365.00 365
1068 3/26/15 560.79 561
1072 3/25/15 2,155.00 2,155
Vendor 800 totals: 4,355.79 4,356
900 1069 3/25/15 553.98 554
Date 03/11/2015 Time 15:32:58 XYZ Company Report #0049 Page 0002
C A S H D I S B U R S E M E N T S P R O J E C T I O N
------------------------------------------------------------------------------------------------------------------------------------
--------Cash required for------- WEEK WEEK MON MON MON QTR
Vend-# Vchr-# As-of Amount ending ending ending ending ending ending
Pmt-grp date 3/11/15 3/18/15 4/18/15 5/18/15 6/18/15 9/18/15
------------------------------------------------------------------------------------------------------------------------------------
Vendor 900 totals: 553.98 554
1000 1058 1/25/15 2,965.00 2,965
1070 1/24/15 8,540.00 8,540
Vendor 1000 totals: 11,505.00 11,505
Grand totals: 44,323.90 37,885 6,439
-- End of report --
Date 03/11/2015 Time 15:36:55 XYZ Company Report #0050 Page 0001
C A S H R E Q U I R E M E N T S
Thru 06/01/15 for payment on 04/01/15 (Next payment date is 06/24/15)
Starting vendor #: “First” Payment group: “All”
Ending vendor #: “Last” A/P account #: “All”
Lost discounts are noted with a “Y” after the discount amount.
------------------------------------------------------------------------------------------------------------------------------------
Vend-# Vendor-name Gross-amount Valid-discount Lost-discount Net-amount
Pmt-grp Vendor-terms
A/P-account
------------------------------------------------------------------------------------------------------------------------------------
100 Vermont Metal Products Past due: 6,775.55 135.51 .00 6,640.04
MFG 2/10 net 31 Current: 1,490.54 29.13 .00 1,461.41
2000-000 Optional: .00 .00 .00
Total: 8,266.09 164.64 .00 8,101.45
Vchr-# Inv-# Inv-date Due-date Disc-dte Past-due-amt Current-amt Optional-amt Discount-amt Lost? Net-amt
1061 34 1/24/15 4/10/15 4/10/15 965.60 19.31 946.29
1071 5 1/24/15 2/10/15 2/10/15 925.00 18.50 906.50
1074 490 1/28/15 2/10/15 2/10/15 3,500.00 70.00 3,430.00
1075 401 1/27/15 2/10/15 2/10/15 2,350.55 47.01 2,303.54
1083 44455 3/10/15 4/10/15 4/10/15 125.60 2.51 123.09
1085 934898 3/10/15 4/10/15 4/10/15 399.34 7.31 392.03
200 Acme Office Supplies Past due: 6,223.25 .00 124.47 6,223.25
SPL 2/15 net 30 Current: .00 .00 .00 .00
2000-000 Optional: .00 .00 .00
Total: 6,223.25 .00 124.47 6,223.25
Vchr-# Inv-# Inv-date Due-date Disc-dte Past-due-amt Current-amt Optional-amt Discount-amt Lost? Net-amt
1059 10 1/22/15 2/21/15 2/06/15 1,625.00 32.50 Y 1,625.00
1062 35 1/23/15 2/22/15 2/07/15 2,500.75 50.02 Y 2,500.75
1073 2 1/23/15 2/22/15 2/07/15 2,097.50 41.95 Y 2,097.50
300 Red Line Freight Past due: 450.45 .00 .00 450.45
EXP net 30 Current: 39.00 .00 .00 39.00
2000-000 Optional: .00 .00 .00
Total: 489.45 .00 .00 489.45
Vchr-# Inv-# Inv-date Due-date Disc-dte Past-due-amt Current-amt Optional-amt Discount-amt Lost? Net-amt
1063 36 1/23/15 2/15/15 None 450.45 .00 450.45
1084 4938 3/10/15 4/15/15 None 39.00 .00 39.00
400 Jones Property Management Past due: 11,000.00 .00 .00 11,000.00
RNT Monthly payment Current: .00 .00 .00 .00
2000-000 Optional: .00 .00 .00
Total: 11,000.00 .00 .00 11,000.00
Vchr-# Inv-# Inv-date Due-date Disc-dte Past-due-amt Current-amt Optional-amt Discount-amt Lost? Net-amt
1064 37 1/23/15 1/27/15 None 11,000.00 .00 11,000.00
Date 03/11/2015 Time 15:36:55 XYZ Company Report #0050 Page 0003
C A S H R E Q U I R E M E N T S
------------------------------------------------------------------------------------------------------------------------------------
Vend-# Vendor-name Gross-amount Valid-discount Lost-discount Net-amount
Pmt-grp Vendor-terms
A/P-account
------------------------------------------------------------------------------------------------------------------------------------
Vchr-# Inv-# Inv-date Due-date Disc-dte Past-due-amt Current-amt Optional-amt Discount-amt Lost? Net-amt
1070 58 1/24/15 1/24/15 None 8,540.00 .00 8,540.00
Grand totals Past due: 42,794.36 386.54 124.47 42,407.82
Current: 1,529.54 29.13 .00 1,500.41
Optional: .00 .00 .00
Total: 44,323.90 415.67 124.47 43,908.23
-- End of report --
Date 03/11/2015 Time 16:35:29 XYZ Company Report #0051 Page 0001
P R E - C H E C K W R I T I N G R E P O R T
Thru 6/01/15 for payment on 4/01/15
Vendors with credit totals are not included in totals
------------------------------------------------------------------------------------------------------------------------------------
Vend-# Name Vchr-# Invc-# Invoice Due Discount Amount Discount Net-cash
Vendor-terms Pmt-grp date date date to-be-paid to-be-taken required
------------------------------------------------------------------------------------------------------------------------------------
200 Acme Office Supplies 1059 10 1/22/15 2/21/15 2/06/15 800.00 5.00 795.00
2/15 net 30 SPL
Vendor totals: 800.00 5.00 795.00
1 vendors to be paid Grand totals: 800.00 5.00 795.00
Date 03/11/2015 Time 16:35:29 XYZ Company Report #0051 Page 0002
P R E - C H E C K W R I T I N G R E P O R T
Deferred vouchers:
------------------------------------------------------------------------------------------------------------------------------------
Vend-# Name Vchr-# Invc-# Invoice Due Discount Amount Discount Net-cash
Vendor-terms Pmt-grp date date date to-be-paid to-be-taken required
------------------------------------------------------------------------------------------------------------------------------------
900 Reynolds Tool Company 1069 390 1/24/15 3/25/15 2/18/15 553.98 33.24 Deferred
6/25 net 60 TLS
-- End of report --
Date 03/12/2015 Time 10:30:09 XYZ Company Report #0054 Page 0001
A / P V O I D E D C H E C K S E D I T L I S T
Voucher status: P = Purged M = selected for Manual payment S = Selected for payment by computer check Blank = OK to void check
------------------------------------------------------------------------------------------------------------------------------------
Cash-acct-# Chk-# Chk-date Check-type Dist-date Reference
------------------------------------------------------------------------------------------------------------------------------------
1000-000 1018 3/10/15 Computer chk 3/10/15 Shipment returned
Vend-# Name Vchr-# Inv-# Inv-date Tot-amt Disc-amt Net-check-amt Status
200 Acme Office Supplies 1059 10 1/22/15 800.00 5.00 795.00
Check totals: 800.00 5.00 795.00
1 Regular checks Grand totals: 800.00 5.00 795.00
0 Manual checks
-- End of report --
Date 03/12/2015 Time 10:30:54 XYZ Company Report #0055 Page 0001
A / P V O I D E D C H E C K S R E G I S T E R
Voucher status: P = Purged M = selected for Manual payment S = Selected for payment by computer check Blank = OK to void check
------------------------------------------------------------------------------------------------------------------------------------
Cash-acct-# Chk-# Chk-date Check-type Dist-date Reference
------------------------------------------------------------------------------------------------------------------------------------
1000-000 1018 3/10/15 Computer chk 3/10/15 Shipment returned
Vend-# Name Vchr-# Inv-# Inv-date Tot-amt Disc-amt Net-check-amt Status
200 Acme Office Supplies 1059 10 1/22/15 800.00 5.00 795.00
Check totals: 800.00 5.00 795.00
1 Regular checks Grand totals: 800.00 5.00 795.00
0 Manual checks
-- End of report --
Date 03/12/2015 Time 10:38:48 XYZ Company Report #0056 Page 0001
O P E N P A Y A B L E S B Y D A T E
Payables as-of: 6/30/15 Starting vendor #: “First” A/P account #: “All”
Ending vendor #: “Last”
------------------------------------------------------------------------------------------------------------------------------------
Inv-# Inv-date Orig-amount Open-amount ----First----- P.O.-#
Orig-discount Open-discount Jrnl-# Vchr-# Reference
------------------------------------------------------------------------------------------------------------------------------------
A/P account #: 2000-000
Vendor: 100 Vermont Metal Products
34 1/24/15 965.60 965.60 AP000020 1061
19.31 19.31
Doc-# Doc-date Amount Discount Doc-type Dist-dte Jrnl-# Vchr-# P.O.-#/Cash-acct
34 1/24/15 965.60 19.31 Invoice 1/24/15 AP000020 1061
401 1/27/15 2,350.55 2,350.55 AP000022 1075
47.01 47.01
Doc-# Doc-date Amount Discount Doc-type Dist-dte Jrnl-# Vchr-# P.O.-#/Cash-acct
401 1/27/15 2,350.55 47.01 Invoice 1/27/15 AP000022 1075
44455 3/10/15 125.60 125.60 AP000042 1083
2.51 2.51
Doc-# Doc-date Amount Discount Doc-type Dist-dte Jrnl-# Vchr-# P.O.-#/Cash-acct
44455 3/10/15 125.60 2.51 Invoice 3/10/15 AP000042 1083
490 1/28/15 3,500.00 3,500.00 AP000022 1074
70.00 70.00
Doc-# Doc-date Amount Discount Doc-type Dist-dte Jrnl-# Vchr-# P.O.-#/Cash-acct
490 1/28/15 3,500.00 70.00 Invoice 1/28/15 AP000022 1074
5 1/24/15 925.00 925.00 AP000021 1071 5
18.50 18.50
Doc-# Doc-date Amount Discount Doc-type Dist-dte Jrnl-# Vchr-# P.O.-#/Cash-acct
5 1/24/15 925.00 18.50 Invoice 1/24/15 AP000021 1071 5
934898 3/10/15 399.34 399.34 AP000042 1085
7.31 7.31
Doc-# Doc-date Amount Discount Doc-type Dist-dte Jrnl-# Vchr-# P.O.-#/Cash-acct
934898 3/10/15 399.34 7.31 Invoice 3/10/15 AP000042 1085
Date 03/12/2015 Time 10:38:49 XYZ Company Report #0056 Page 0008
O P E N P A Y A B L E S B Y D A T E
------------------------------------------------------------------------------------------------------------------------------------
Inv-# Inv-date Orig-amount Open-amount ----First----- P.O.-#
Orig-discount Open-discount Jrnl-# Vchr-# Reference
------------------------------------------------------------------------------------------------------------------------------------
Open payable grand totals: 44,323.90
540.14
-- End of report --
Date 03/12/2015 Time 10:49:27 XYZ Company Report #0057 Page 0001
V E N D O R H I S T O R Y
Start date: “Earliest” Starting vendor: “First” A/P account #: “All”
Cut-off date: “Latest” Ending vendor: “Last” Payment group: “All”
------------------------------------------------------------------------------------------------------------------------------------
Inv-# Inv-date Orig-amount Open-amount ----First----- P.O.-#
Orig-discount Open-discount Jrnl-# Vchr-# Reference
------------------------------------------------------------------------------------------------------------------------------------
Vendor: 100 Vermont Metal Products A/P acct #: 2000-000 Pmt Group: MFG
Doc-# Doc-date Amount Discount Doc-type Dist-dte Jrnl-# Vchr-# P.O.-#/Cash-acct
34 1/24/15 965.60 19.31 Invoice 1/24/15 AP0000020 1061
34 1/24/15 965.60 965.60 AP0000020 1061
19.31 19.31
Doc-# Doc-date Amount Discount Doc-type Dist-dte Jrnl-# Vchr-# P.O.-#/Cash-acct
401 1/27/15 2,350.55 47.01 Invoice 1/27/15 AP0000022 1075
401 1/27/15 2,350.55 2,350.55 AP0000022 1075
47.01 47.01
Doc-# Doc-date Amount Discount Doc-type Dist-dte Jrnl-# Vchr-# P.O.-#/Cash-acct
44455 3/10/15 125.60 2.51 Invoice 3/10/15 AP0000042 1083
44455 3/10/15 125.60 125.60 AP0000042 1083
2.51 2.51
Doc-# Doc-date Amount Discount Doc-type Dist-dte Jrnl-# Vchr-# P.O.-#/Cash-acct
490 1/28/15 3,500.00 70.00 Invoice 1/28/15 AP0000022 1074
490 1/28/15 3,500.00 3,500.00 AP0000022 1074
70.00 70.00
Doc-# Doc-date Amount Discount Doc-type Dist-dte Jrnl-# Vchr-# P.O.-#/Cash-acct
5 1/24/15 925.00 18.50 Invoice 1/24/15 AP0000021 1071 5
5 1/24/15 925.00 925.00 AP0000021 1071 5
18.50 18.50
Doc-# Doc-date Amount Discount Doc-type Dist-dte Jrnl-# Vchr-# P.O.-#/Cash-acct
934898 3/10/15 399.34 7.31 Invoice 3/10/15 AP0000042 1085
934898 3/10/15 399.34 399.34 AP0000042 1085
7.31 7.31
Totals: 8,266.09 8,266.09
164.64 164.64
------------------------------------------------------------------------------------------------------------------------------------
Date 03/12/2015 Time 10:49:27 XYZ Company Report #0057 Page 0004
V E N D O R H I S T O R Y
------------------------------------------------------------------------------------------------------------------------------------
Inv-# Inv-date Orig-amount Open-amount ----First----- P.O.-#
Orig-discount Open-discount Jrnl-# Vchr-# Reference
------------------------------------------------------------------------------------------------------------------------------------
Vendor: 800 Hanson Manufacturing Co. A/P acct #: 2000-000 Pmt Group: MFG
Doc-# Doc-date Amount Discount Doc-type Dist-dte Jrnl-# Vchr-# P.O.-#/Cash-acct
4 1/24/15 2,155.00 107.75 Invoice 1/24/15 AP0000021 1072 4
Doc-# Doc-date Amount Discount Doc-type Dist-dte Jrnl-# Vchr-# P.O.-#/Cash-acct
8 1/24/15 365.00 18.25 Invoice 1/24/15 AP0000019 1060 8
8 1/24/15 365.00 365.00 AP0000019 1060 8
18.25 18.25
Doc-# Doc-date Amount Discount Doc-type Dist-dte Jrnl-# Vchr-# P.O.-#/Cash-acct
89 1/25/15 560.79 28.04 Invoice 1/25/15 AP0000020 1068
89 1/25/15 560.79 560.79 AP0000020 1068
28.04 28.04
Totals: 4,355.79 4,355.79
217.79 217.79
------------------------------------------------------------------------------------------------------------------------------------
Vendor: 900 Reynolds Tool Company A/P acct #: 2000-000 Pmt Group: TLS
Doc-# Doc-date Amount Discount Doc-type Dist-dte Jrnl-# Vchr-# P.O.-#/Cash-acct
390 1/24/15 553.98 33.24 Invoice 1/24/15 AP0000020 1069
390 1/24/15 553.98 553.98 AP0000020 1069
33.24 33.24
------------------------------------------------------------------------------------------------------------------------------------
Vendor: 1000 Greener Grass Ofc. Plants A/P acct #: 2000-000 Pmt Group:
Doc-# Doc-date Amount Discount Doc-type Dist-dte Jrnl-# Vchr-# P.O.-#/Cash-acct
13 1/25/15 2,965.00 .00 Invoice 1/25/15 AP0000018 1058 13
13 1/25/15 2,965.00 2,965.00 AP0000018 1058 13
.00 .00
Doc-# Doc-date Amount Discount Doc-type Dist-dte Jrnl-# Vchr-# P.O.-#/Cash-acct
58 1/24/15 8,540.00 .00 Invoice 1/24/15 AP0000020 1070
58 1/24/15 8,540.00 8,540.00 AP0000020 1070
.00 .00
Totals: 11,505.00 11,505.00
Date 03/12/2015 Time 10:49:27 XYZ Company Report #0057 Page 0005
V E N D O R H I S T O R Y
------------------------------------------------------------------------------------------------------------------------------------
Inv-# Inv-date Orig-amount Open-amount ----First----- P.O.-#
Orig-discount Open-discount Jrnl-# Vchr-# Reference
------------------------------------------------------------------------------------------------------------------------------------
.00 .00
------------------------------------------------------------------------------------------------------------------------------------
Grand totals: 44,323.90 44,323.90
540.14 540.14
-- End of report --
Date 03/12/2015 Time 11:30:19 XYZ Company Report #0058 Page 0001
P U R G E V E N D O R H I S T O R Y
Cut-off date: 1/22/15 Starting vendor: “First” A/P account #: “All”
Ending vendor: “Last” Payment group: “All”
------------------------------------------------------------------------------------------------------------------------------------
Inv-# Inv-date Orig-amount Open-amount ----First----- P.O.-#
Orig-discount Open-discount Jrnl-# Vchr-# Reference
------------------------------------------------------------------------------------------------------------------------------------
Vendor: * None * (the following checks were either not accounted for or voided)
Chk-# Chk-date Amount Disc Doc-type Cash-acct-# Dist-dte Jrnl-# Vchr-#
1018 3/10/15 .00 Void check 1000-000 3/10/15 AV0000055
------------------------------------------------------------------------------------------------------------------------------------
-- End of report --
Date 03/12/2015 Time 11:40:13 XYZ Company Report #0059 Page 0001
C H E C K R E G I S T E R
“*” next to Check amount is for retainage paid
------------------------------------------------------------------------------------------------------------------------------------
Chk-# Chk-date Vend-# Name Vchr-# Inv-# Inv-date Amount Discount Check
paid taken amount
------------------------------------------------------------------------------------------------------------------------------------
Cash account: 1000-000 Cash account #13557
1019 3/10/15 300 Red Line Freight 1063 36 1/23/15 450.45 .00 450.45
1020 3/10/15 700 Pacific Telephone 1067 100A 1/25/15 990.34 .00 990.34
Cash account totals: 1,440.79 .00 1,440.79
2 Regular checks Grand totals: 1,440.79 .00 1,440.79
0 Non-A/P checks
0 Manual checks
0 Void checks
2 Checks total
-- End of report --
Fully Paid Open Items Purge Report
Date 03/12/2015 Time 11:41:00 XYZ Company Report #0060 Page 0001
F U L L Y P A I D O P E N I T E M S P U R G E R E P O R T
Cut-off due date: “Latest” Starting vendor: “First” A/P account #: 2000-000
Ending vendor: “Last” Payment group: “All”
------------------------------------------------------------------------------------------------------------------------------------
Vchr-# Inv-# Inv-date Due-date Disc-dat P.O.-# Orig-inv-amt Orig-disc-amt
------------------------------------------------------------------------------------------------------------------------------------
Vendor: 300 Red Line Freight A/P acct #: 2000-000 Pmt Group: EXP
1063 36 1/23/15 2/15/15 450.45 .00
Vendor totals: 450.45 .00
Vendor: 700 Pacific Telephone A/P acct #: 2000-000 Pmt Group: UTL
1067 100A 1/25/15 2/14/15 990.34 .00
Vendor totals: 990.34 .00
2 open items Grand totals: 1,440.79 .00
-- End of report --
Date 03/12/2015 Time 11:48:03 XYZ Company Report #0061 Page 0001
T E M P O R A R Y V E N D O R P U R G E R E P O R T
Starting vendor #: “First” Payment group: “All”
Ending vendor #: “Last” A/P account #: “All”
Vendor status: Blank = normal A = always take discount H = hold payment N = not to be purchased from
Terms types: D = days P = proximo (day of next month)
EOM = end of current month
------------------------------------------------------------------------------------------------------------------------------------
Vend-# Name Contact-1 Phone-1 Purchases-YTD Purchased-lst-yr A/P-acct-# ---- Terms -----
Status Address Contact-2 Phone-2 Discounts-YTD Discounts-lst-yr Disc-acct-# Type Due-days
Type Vend-ref-# 1099-ID-# 1099-amt-YTD 1099-amt-nxt-yr Dflt-dist-acct-# Cutoff Disc-days
Pmt-grp 1099-ID-type Last-purch-date Disc-%
------------------------------------------------------------------------------------------------------------------------------------
*TVEN Trenton Industries Tim Thornton 388-499-7843 .00 .00 2000-000 no terms
200 Miami Blvd .00 .00 5050-100 Days 0
TMP Sarasota, FL 58332 .00 .00 1200-100 N/A None
TMP None 0.00
Country: USA
1 Temporary vendors
-- End of report --
Payables Distributions to General Ledger
Date 03/12/2015 Time 11:55:18 XYZ Company Report #0062 Page 0001
P A Y A B L E S D I S T R I B U T I O N S T O G E N E R A L L E D G E R
Starting date: “Earliest” Starting account #: “First”
Ending date: “Latest” Ending account #: “Last”
Journal types: AP = A/P transaction register AJ = Adjustment register AK = A/P check register AV = A/P voided checks register
------------------------------------------------------------------------------------------------------------------------------------
Acct-# Description
Date Vchr-# Vend-# Name Invoice-# Reference Jrnl-# Amount Typ
------------------------------------------------------------------------------------------------------------------------------------
Manual distributions in detail
5010-100 Purchases - misc. items
1/24/15 1061 100 Vermont Metal Products 34 AP0020 965.60 POS
1/27/15 1075 100 Vermont Metal Products 401 AP0022 2,350.55 POS
1/28/15 1074 100 Vermont Metal Products 490 AP0022 3,500.00 POS
3/10/15 1083 100 Vermont Metal Products 44455 AP0042 125.60 POS
3/10/15 1084 300 Red Line Freight 4938 AP0042 5.00 ACH
3/10/15 1085 100 Vermont Metal Products 934898 AP0042 399.34 POS
Date total: 529.94
Account total: 7,346.09
5020-100 Purchases - tools
1/24/15 1069 900 Reynolds Tool Company 390 AP0020 553.98 CHK
1/25/15 1068 800 Hanson Manufacturing Co. 89 AP0020 560.79 CHK
Account total: 1,114.77
5040-100 Freight - purchases
1/23/15 1063 300 Red Line Freight 36 AP0020 450.45 ACH
3/10/15 1084 300 Red Line Freight 4938 AP0042 34.00 ACH
Account total: 484.45
5070-000 Inventory expenses
1/22/15 1059 200 Acme Office Supplies 10 AP0019 1,625.00
1/23/15 1057 800 Hanson Manufacturing Co. 12 AP0018 1,275.00
1/23/15 1073 200 Acme Office Supplies 2 AP0021 2,097.50
Date total: 3,372.50
1/24/15 1060 800 Hanson Manufacturing Co. 8 AP0019 365.00
1/24/15 1071 100 Vermont Metal Products 5 AP0021 925.00
1/24/15 1072 800 Hanson Manufacturing Co. 4 AP0021 2,155.00
Date 03/12/2015 Time 11:55:18 XYZ Company Report #0062 Page 0007
P A Y A B L E S D I S T R I B U T I O N S T O G E N E R A L L E D G E R
Starting date: “Earliest” Starting account #: “First”
Ending date: “Latest” Ending account #: “Last”
Journal types: AP = A/P transaction register AJ = Adjustment register AK = A/P check register AV = A/P voided checks register
------------------------------------------------------------------------------------------------------------------------------------
Acct-# Description
Date Chk-# Cash-acct-# Vend-# Name Reference Jrnl-# Amount Typ
------------------------------------------------------------------------------------------------------------------------------------
A/P paid distributions in detail
2000-000 Accounts payable
3/10/15 1018 1000-000 200 Acme Office Supplies Acme Office Supplies AK0053 800.00 CHK
3/10/15 1018 1000-000 200 Acme Office Supplies Shipment returned AV0055 800.00CR CHK
3/10/15 1019 1000-000 300 Red Line Freight Red Line Freight AK0059 450.45 ACH
3/10/15 1020 1000-000 700 Pacific Telephone Pacific Telephone AK0059 990.34 ACH
Date total: 1,440.79
Account total: 1,440.79
Section total: 1,440.79
Report total: .00
-- End of report --
Date 03/12/2015 Time 12:03:57 XYZ Company Report #0063 Page 0001
P U R C H A S E S / D I S C O U N T S
------------------------------------------------------------------------------------------------------------------------------------
Vend-# Name Last ----------------Year-to-date---------------- -----------------Last-year-----------------
purchase Purchases Pct-of Discounts Pct-of Purchases Pct-of Discounts Pct-of
date total total total total
------------------------------------------------------------------------------------------------------------------------------------
Vendor type: (Blank)
777 Harmon Industries None .00 0.0 .00 0.0 .00 0.0 .00 0.0
Type totals: .00 .00 .00 .00
0.0 0.0 0.0 0.0
Average for vendor type: .00 .00 .00 .00
Vendor type: CAP
200 Acme Office Supplies 1/23/15 18,390.84 21.2 .00 0.0 .00 0.0 .00 0.0
Type totals: 18,390.84 .00 .00 .00
21.2 0.0 0.0 0.0
Average for vendor type: 18,390.84 .00 .00 .00
Vendor type: EXP
300 Red Line Freight 3/10/15 3,366.45 3.9 .00 0.0 .00 0.0 .00 0.0
400 Jones Property Management 1/23/15 14,742.60 17.0 .00 0.0 .00 0.0 .00 0.0
500 E-Z Repairs 1/22/15 4,064.00 4.7 .00 0.0 .00 0.0 .00 0.0
600 Wells Fargo Bank 1/22/15 103.75 0.1 .00 0.0 .00 0.0 .00 0.0
700 Pacific Telephone 1/25/15 3,324.89 3.8 .00 0.0 .00 0.0 .00 0.0
Type totals: 25,601.69 .00 .00 .00
29.5 0.0 0.0 0.0
Average for vendor type: 5,120.34 .00 .00 .00
Vendor type: MFG
100 Vermont Metal Products 3/10/15 18,063.57 20.8 93.81 100.0 .00 0.0 .00 0.0
Type totals: 18,063.57 93.81 .00 .00
20.8 100.0 0.0 0.0
Average for vendor type: 18,063.57 93.81 .00 .00
Vendor type: PCH
800 Hanson Manufacturing Co. 1/25/15 11,595.79 13.3 .00 0.0 .00 0.0 .00 0.0
900 Reynolds Tool Company 1/24/15 689.88 0.8 .00 0.0 .00 0.0 .00 0.0
Type totals: 12,285.67 .00 .00 .00
14.1 0.0 0.0 0.0
Average for vendor type: 6,142.84 .00 .00 .00
Date 03/12/2015 Time 12:03:57 XYZ Company Report #0063 Page 0002
P U R C H A S E S / D I S C O U N T S
------------------------------------------------------------------------------------------------------------------------------------
Vend-# Name Last ----------------Year-to-date---------------- -----------------Last-year-----------------
purchase Purchases Pct-of Discounts Pct-of Purchases Pct-of Discounts Pct-of
date total total total total
------------------------------------------------------------------------------------------------------------------------------------
Vendor type: SVC
1000 Greener Grass Ofc. Plants 1/25/15 12,575.45 14.5 .00 0.0 .00 0.0 .00 0.0
Type totals: 12,575.45 .00 .00 .00
14.5 0.0 0.0 0.0
Average for vendor type: 12,575.45 .00 .00 .00
11 Vendors Grand totals: 86,917.22 93.81 .00 .00
6 Types 100.0 100.0 0.0 0.0
Averages: 7,901.57 8.53 .00 .00
-- End of report --
Date 03/12/2015 Time 12:43:43 XYZ Company Report #0064 Page 0001
1 0 9 9 R E P O R T -- B R I E F F O R M A T
** by 1099 amount indicates vendor is below reporting limit of 600.00
------------------------------------------------------------------------------------------------------------------------------------
Ven-# Name 1099-ID 1099-amt Address Phone-#
------------------------------------------------------------------------------------------------------------------------------------
100 Vermont Metal Products 12-7659821 4,596.69 410 Pinecrest Road 802-445-9134
200 Acme Office Supplies 12-3456789 67.59 ** 456 N. Broadway 213-999-9765
300 Red Line Freight 12-3456789 450.45 ** 22748 E. Commercial 213-768-7650
800 Hanson Manufacturing Co. 12-3456789 0.00 ** 65 Industrial Circle 847-669-8560
1000 Greener Grass Ofc. Plants 55-5434211 0.00 ** 324 N Winter Dr. 714-555-2344
518.04 paid to 4 vendors below reporting limit
4,596.69 paid to 1 vendors at or above reporting limit
5,114.73 paid to 5 vendors printed
-- End of report --
Date 02/13/2015 Time 16:28:49 XYZ Company Report #0100013 Page 0001
1 0 9 9 R E P O R T -- F U L L F O R M A T
** by 1099 amount indicates non-reportable 1099. Vendor # range: First - Last
Minimum 1099 reportable amount required for boxes 1, 3, 6, 7, 10 and 15a 600.00 1099 year end date: 12/31/2014
Minimum 1099 reportable amount required for boxes 2 and 8 10.00 Report year-end: 2014
Minimum 1099 reportable amount required for boxes 4, 5, 13, 14 and 15b 0.01
------------------------------------------------------------------------------------------------------------------------------------
Ven-# Name 1099-ID Calc'd-1099-amt Ovr'd-1099-amt Address Phone-#/Cntry
------------------------------------------------------------------------------------------------------------------------------------
400 Jones Property Management 99-1254783 11056 Wilshire Blvd. 213-774-6700 USA
Suite 4250
Los Angeles CA 92251
Rents 4,500.00 4,500.00
Other income 1,855.00 1,855.00
Total 6,355.00 6,355.00
JM Shirley Adams 387-58-1235 1,535.63 1,535.63 7845 Main Lane
Non-Employee comp Village IL 60000
Calc'd-1099-amt
0.00 paid to 7 vendors with non-reportable 1099
7,890.63 paid to 2 vendors with reportable 1099s
7,890.63 9 vendors processed
Ovr'd-1099-amt
0.00 pd to 7 vendors with non-reportable 1099
7,890.63 pd to 2 vendors with reportable 1099s
7,890.63 9 vendors processed
-- End of report --
Magnetic 1099 Exception Report
Date 03/12/2015 Time 13:20:07 XYZ Company Report #0067 Page 0001
M A G N E T I C 1 0 9 9 E X C E P T I O N R E P O R T
------------------------------------------------------------------------------------------------------------------------------------
Payee-# Payee-name Street-address Tax-ID-# 1099-amount
Phone-# City St Zip
------------------------------------------------------------------------------------------------------------------------------------
NO ERRORS FOUND.
Use the following information for inclusion on form 4804:
Transmitter control code ABCDE
Payer’s name XYZ COMPANY
Payer’s address 500 W. LINCOLN BLVD.
City ANYTOWN
State TX
Zip code 12345
Federal ID # 991135917
Number of 1099 forms 1
Total vendor
compensation reported 4,596.69 (Amount code 7)
-- End of report --